Level 3 Payment Information
Level 3 payment information provides detailed information about the overall order and individual line item(s) being purchased.
This page is included for informational purposes only.
Level 3 Payment Information Provided to Gateways
Below is the list of Level 3 Payment Information provided to the payment gateways.
Order Level Data
| AlternateTaxAmount | - MasterCard version of VAT (Value Added Tax).
- Mapped to VATAlternateTaxAmount.
- For each Invoice Detail (ivd_type=product) query database with prd_key to get tax_linked_flag from oe_tax_product. If “1” then invoice detail has VAT/Alternate Tax Amount. Add these together to get full amount.
OR - Look up destination address country in co_country. If cty_vat_flag is set then Invoice Details are VAT/Alternate Tax.
- NOTE:
|
| AlternateTaxRate | - MasterCard version of VAT (Value Added Tax).
- Mapped to VATAlternateTaxRate.
- For each Invoice Detail look at each AdditionalInvoiceDetail and add up the prc_percent. This gets us the tax rate.
|
| DesintationCountryISONumber | - Get Destination address (see Level 2 Destination Address), use adr_country to retrieve cty_iso_number from co_country table.
|
| DestinationZip | - Obtained from Level 2 Destination Zip (see Level 2 Destination Zip).
|
| DiscountAmount | - For each Invoice Detail, if ivd_type=discount, add them up to get the full discount amount.
|
| DutyAmount | - Not currently supported by NetForum, always passes $0.00.
|
| FreightAmount | - For each Invoice Detail, if ivd_type=shipping, add them up to get the full shipping amount..
|
| NationalTaxAmount | - A specific type of tax, can also be used in Tax Type for each line item.
- For each Invoice Detail, if ivd_type=product, use prd_key to select the following from oe_tax_product:
- tax_cty_key
- tax_county
- tax_city
- tax_post_code_min
- tax_post_code_max
- If tax_cty_key is not empty and tax_county, tax_city, tax_post_code_min, tax_post_code_max are empty, this is considered NationalTaxAmount
- If criteria is met, sum ivd_price.
|
| ShipFromZip | - From the first InvoiceDetail use ivd_prc_prd_key to retrieve the ivw_whs_key from oe_inventory_x_warehouse. Use ivw_whs_key to get the adr_post_code where the items are being shipped from.
|
| VATInvoiceNumber | - From Payment façade (passed to Mapper), use inv_code.
|
| VATNumber | - If invoice has VAT Tax (see Vat Tax Amount), then use the CardAcceptorID (from Level 2) as the Tax ID of the seller.
|
| VATTaxAmount | - Visa specific field for VAT, see AlternateTaxAmount
|
| VATTaxRate | - Visa specific field for VAT, see AlternateTaxRate.
|
Line Item Data
| AlternateTaxIdentifier | - Not currently supported by NetForum.
- Sage-specific field
- Can have a 'Null' value - This tag contains information about the taxes applied in specific areas, such as states, zip codes or postal codes. (Subtag examples: us-state-area, us-zip-area, us-country-area, postal-area, world-area)
|
| CommodityCode | - New field added to NetForum.
- New Table added: oe_commodity_code.
- New fields added to oe_product (prd_cmo_key) and oe_product_type (ptp_cmo_key) tables.
- For the invoice detail being looked at, use the prd_cmo_key (product commodity code key) first to get the cmo_code from the oe_commodity_code table. If it is empty, use the ptp_cmo_key to get the cmo_code from the oe_commodity_code table.
- To use in iWeb, field is accessible from the product and product type profile pages.
- When the commodity code is evaluated, the system first looks at the product for the code. If it is null, then the product type’s commodity code will be used.
- To add or change commodity codes go to the Inventory module, use Group Item Links to Find, List and Add commodity codes.
|
| Description | - For the invoice detail being looked at get prc_display_name from Invoice Detail.
|
| Discount | - Set to true if ivd_type=discount, otherwise false from Invoice Detail.
|
| DiscountRate | - If ivd_type = discount, get ivd_price and use as Discount Rate from Invoice Detail.
|
| IndexNumber | |
| LineTotal | - Use ivd_amount_cp as Line Total from Invoice Detail.
|
| ProductCode | - Use prd_code as Product Code from Invoice Detail.
|
| Quantity | - Use ivd_qty as Quantity from Invoice Detail.
|
| TaxAmount | - Use ivd_tax as Tax Amount from Invoice Detail.
|
| TaxRate | - For each Additional Invoice Detail on the Invoice Detail sum the prc_percent field.
|
| TaxTypeApplied | Mapped to TaxType. New table added: oe_tax_type. New fields added to oe_tax_product (tax_tty_key). Using the prc_key get tax_tty_key from oe_tax_product joining oe_tax_product. If tax_tty_key is not empty get tty_code from oe_tax_type. To access this field in iWeb go to Tax Product Profile Page. To add or change Tax Types go to the Inventory Module, use Group Item Links to Find, Add, List Tax Types
|
| UnitCost | - Use ivd_price from Invoice Detail.
|
| UnitOfMeasure | - NetForum does not currently support this field, however it is hardcoded to “EA” to stand for Each.
|